/**
 * 
 */
package monster.flight.comm.util.mobile.factory;

//import jsoft.com.util.DBManager;

/**
 * 发送短信
 * @author wanghong
 * 2012-9-21
 * SendSMS.java
 * 
 */
public class SendSMS {
	public void exec(){
    	try{
    		/**
	    	DBManager db = new DBManager();
	    	String sql="update  COMM_QUEST_LIB  set KG_NUM = a.n,ZG_NUM = a.m "+
                   "  from (select a.lib_sn,count(case when b.QUE_TYPE<'02' then 1 else null end ) n,count(case when b.QUE_TYPE>'02000' then 1 else null end ) m from COMM_QUE_LIB_QUES a,COMM_QUESTIONS b,COMM_QUEST_LIB c where c.lib_sn=a.lib_sn and a.que_sn=b.que_sn group by a.lib_sn)a"+
                   "  where COMM_QUEST_LIB.lib_sn=a.lib_sn";
	    	db.update(sql);
	    	**/
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		
    	}
    	
    }
}
